﻿CREATE PROCEDURE [dbo].[sp_Get_CityByMdAndCounty]
	@mdnumber varchar(10), 
	@county varchar(200)
AS
	select distinct City from dbo.ZipInfo 
	WHERE MdNumber = @mdnumber and County = @county order by City